www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/lxrxx.cpp

    // lxrxx.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "lxrxx.h"
#include "ado.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
ado rst2;
int num=1;
int num2;
int sel=1;
int xiugai;
/////////////////////////////////////////////////////////////////////////////
// lxrxx dialog


lxrxx::lxrxx(CWnd* pParent /*=NULL*/)
	: CDialog(lxrxx::IDD, pParent)
{
	//{{AFX_DATA_INIT(lxrxx)
	//}}AFX_DATA_INIT
	
}


void lxrxx::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(lxrxx)
	DDX_Control(pDX, IDC_EDIT9, m_edit9);
	DDX_Control(pDX, IDC_EDIT8, m_edit8);
	DDX_Control(pDX, IDC_EDIT7, m_edit7);
	DDX_Control(pDX, IDC_EDIT6, m_edit6);
	DDX_Control(pDX, IDC_EDIT5, m_edit5);
	DDX_Control(pDX, IDC_EDIT4, m_edit4);
	DDX_Control(pDX, IDC_EDIT3, m_edit3);
	DDX_Control(pDX, IDC_EDIT2, m_edit2);
	DDX_Control(pDX, IDC_EDIT1, m_edit1);
	DDX_Control(pDX, IDC_DATETIMEPICKER2, m_date2);
	DDX_Control(pDX, IDC_DATETIMEPICKER1, m_date1);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO3, m_com3);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_TAB1, m_tab);
	//}}AFX_DATA_MAP
	
}


BEGIN_MESSAGE_MAP(lxrxx, CDialog)
	//{{AFX_MSG_MAP(lxrxx)
	ON_COMMAND(ID_ADD, OnAdd)
	ON_COMMAND(ID_DELETE, OnDelete)
	ON_COMMAND(ID_EXIT, OnExit)
	ON_COMMAND(ID_FIRST, OnFirst)
	ON_COMMAND(ID_LAST, OnLast)
	ON_COMMAND(ID_NEXT, OnNext)
	ON_COMMAND(ID_SAVE, OnSave)
	ON_COMMAND(ID_UP, OnUp)
	ON_COMMAND(ID_UPDATE, OnUpdate)
	ON_WM_PAINT()
	ON_COMMAND(ID_CANCEL, OnCancel)
	ON_NOTIFY(TCN_SELCHANGE, IDC_TAB1, OnSelchangeTab1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// lxrxx message handlers

void lxrxx::OnAdd() 
{
	m_tab.SetCurSel(0);
	this->textshow();
	this->enableall(true);
	this->enbutton(false);
	this->clearall();
	this->numauto();
	sel=0;
	xiugai=0;
}

void lxrxx::OnCancel() 
{
	this->textshow();
	this->datatotext();
	this->texttowin();
	this->enableall(false);
	this->enbutton(true);
	sel=1;
	
}

void lxrxx::OnDelete() 
{
	if(MessageBox("删除后数据将丢失","提示",MB_YESNO)==IDYES)
	{
		CString ss,aa;
	this->m_edit1.GetWindowText(aa);
		ss.Format("delete from tb_Client_lxrxx where lxrxx_id = '%s'",aa);
	rst2.ExecuteSQL(ss);

m_list.DeleteAllItems();
this->loadf();
this->load2();
this->datatotext();
this->texttowin();
	}
	
}

void lxrxx::OnExit() 
{
	CDialog::EndDialog(true);
	
}

void lxrxx::OnFirst() 
{
	m_tab.SetCurSel(0);
	this->textshow();
	rst2.MoveFirst();
	this->datatotext();
	this->texttowin();
	num=1;
}

void lxrxx::OnLast() 
{
	m_tab.SetCurSel(0);
	this->textshow();
	rst2.MoveLast();
	this->datatotext();
	this->texttowin();
	num=num2;
	
}

void lxrxx::OnNext() 
{
	if(num==num2)
	{return;}
	m_tab.SetCurSel(0);
	this->textshow();
	rst2.MoveNext();
	this->datatotext();
	this->texttowin();
	
	num+=1;
}

void lxrxx::OnSave() 
{
	this->wintotext();
	CString ss;
	if(xiugai==1)
	{ss.Format("UPDATE tb_Client_lxrxx set lxrxx_qymc='%s',lxrxx_xm='%s',lxrxx_xb='%s',lxrxx_nl='%s',lxrxx_zw='%s',lxrxx_bgdh='%s',lxrxx_Email='%s',lxrxx_csny='%s',lxrxx_sj='%s',lxrxx_grjj='%s',lxrxx_djrq='%s',lxrxx_xxdjr='%s',lxrxx_bz='%s' where lxrxx_id='%s'",com1,edit2,com2,edit3,com3,edit4,edit5,date1,edit6,edit7,date2,edit8,edit9,edit1);}
	else
	{ss.Format("INSERT INTO tb_Client_lxrxx values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",edit1,com1,edit2,com2,date1,edit3,com3,edit4,edit5,edit6,edit7,date2,edit8,edit9);}
	rst2.ExecuteSQL(ss);
	m_list.DeleteAllItems();
this->loadf();
this->load2();
this->datatotext();
this->texttowin();
this->enableall(false);
	this->enbutton(true);
	sel=1;
	xiugai=0;
}

void lxrxx::OnUp() 
{	if(num==1)
{return;}
	m_tab.SetCurSel(0);
	this->textshow();
	rst2.MovePrevious();
	this->datatotext();
	this->texttowin();
	num-=1;
}

void lxrxx::OnUpdate() 
{
	m_tab.SetCurSel(0);
	this->textshow();
	this->enableall(true);
	this->enbutton(false);
	sel=0;
	xiugai=1;
	
}

BOOL lxrxx::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->m_com2.AddString("男");
	this->m_com2.AddString("女");
	this->m_com3.AddString("董事长");
	this->m_com3.AddString("总经理");
	this->m_com3.AddString("销售主管");
	this->m_com3.AddString("市场主管");
	this->m_com3.AddString("宣传主管");
	this->m_com3.AddString("总工程师");
	this->m_com3.AddString("外联主管");
	this->m_com3.AddString("人力资源主管");
	this->m_com3.AddString("职员");
	ado load;
	load.Open("select * from tb_khxx",adCmdText);
	int rstnum=load.GetRecordCount();
	int l;
	for(l=1;l<=rstnum;l++)
	{
		this->m_com1.AddString(load.GetFieldValue("khxx_mc"));
		load.Move(l);
		
	}

	load.close();
	imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON1)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON2)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON3)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON4)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON5)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON6)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON7)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON8)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON9)));
	imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON10)));
	
	 // int weith[2];
//	weith[1]=150;
//	weith[0]=500;
//	weith[2]=200;
	CString s;
	TCHAR *pString;
	
		
	
	CMenu menu;
	menu.LoadMenu(IDR_lxrxx);
//	this->SetMenu(&menu);
toolbar.EnableAutomation();
	toolbar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_TOOLBAR);
	
	toolbar.SetImageList(&imagelist);
	TBBUTTON button[12];
	int i;
	for(i=0;i<12;i++)
	{
	button[i].dwData=0;
	button[i].fsState=TBSTATE_ENABLED;
	button[i].fsStyle=TBSTYLE_BUTTON;
	}
	button[5].fsStyle=TBSTYLE_SEP;
	button[10].fsStyle=TBSTYLE_SEP;
	button[0].idCommand=ID_ADD;
	button[0].iBitmap=0;
	
	button[1].idCommand=ID_UPDATE;
	button[1].iBitmap=1;
	button[2].idCommand=ID_DELETE;
	button[2].iBitmap=2;
	button[3].idCommand=ID_SAVE;
	button[3].iBitmap=3;
	button[4].idCommand=ID_CANCEL;
	button[4].iBitmap=4;
	button[6].idCommand=ID_FIRST;
	button[6].iBitmap=5;
	button[7].idCommand=ID_UP;
	button[7].iBitmap=6;
	button[8].idCommand=ID_NEXT;
	button[8].iBitmap=7;
	button[9].idCommand=ID_LAST;
	button[9].iBitmap=8;
	button[11].idCommand=ID_EXIT;
	button[11].iBitmap=9;
for(i=0;i<12;i++)
{
	s.LoadString(i+IDS_1);
	int nStringLength= s.GetLength() + 1;
	pString = s.GetBufferSetLength(nStringLength);
	
	button[i].iString =toolbar.AddStrings(pString);
		s.ReleaseBuffer();
}
	toolbar.AddButtons(12,button);
	toolbar.AutoSize();
	toolbar.SetStyle(TBSTYLE_FLAT|CCS_TOP);
	toolbar.EnableButton(ID_SAVE,false);
	toolbar.EnableButton(ID_CANCEL,false);
	m_list.ModifyStyle(0L,LVS_REPORT);
	m_list.ModifyStyle(0L,LVS_SINGLESEL);
	m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_list.ModifyStyle(0L,LVS_NOSORTHEADER);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES);
	m_list.InsertColumn(0,"联系人编号");
	m_list.InsertColumn(1,"企业名称");
	m_list.InsertColumn(2,"联系人姓名");
	m_list.InsertColumn(3,"联系人性别");
	m_list.InsertColumn(4,"年龄");
	m_list.InsertColumn(5,"职位");
	m_list.InsertColumn(6,"办公电话");
	m_list.InsertColumn(7,"电子邮件");
	m_list.InsertColumn(8,"手机");
	m_list.SetColumnWidth(0,100);
m_list.SetColumnWidth(1,100);
m_list.SetColumnWidth(2,100);
m_list.SetColumnWidth(3,100);
m_list.SetColumnWidth(4,100);
m_list.SetColumnWidth(5,100);
m_list.SetColumnWidth(6,100);
m_list.SetColumnWidth(7,100);
m_list.SetColumnWidth(8,100);

m_tab.InsertItem(0,"联系人基本信息");
m_tab.InsertItem(1,"联系人列表");
this->load2();
this->loadf();
this->texttowin();
m_list.ShowWindow(SW_HIDE);
enableall(false);
this->m_edit3.LimitText(2);
	//statebar.EnableAutomation();
	
//if(!statebar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_STATU))
//{
//	return false;
//}
	//statebar.SetParts(4,&weith[1]);
	//statebar.SetText("明日",0,0);
	//statebar.SetText("aa",0,3);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void lxrxx::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	if (IsIconic())
	{
		
		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;
	//	dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

BOOL lxrxx::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
		pMsg->wParam=9;	
	return CDialog::PreTranslateMessage(pMsg);
}
//void lxrxx::show(bool enbale)
//{
	
//}

void lxrxx::OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	if(sel==1)
	{
	int i=m_tab.GetCurSel();
switch(i)

{
case 1:
	
this->listshow();
	break;
case 0:
	

this->textshow();
	break;
}	
	}
	*pResult = 0;
}
void lxrxx::enableall(bool b)
{
	m_edit1.EnableWindow(b);
	m_edit2.EnableWindow(b);
	m_edit3.EnableWindow(b);
	m_edit4.EnableWindow(b);
	m_edit5.EnableWindow(b);
	m_edit6.EnableWindow(b);
	m_edit7.EnableWindow(b);
	m_edit8.EnableWindow(b);
	m_edit9.EnableWindow(b);
	m_com1.EnableWindow(b);
	m_com2.EnableWindow(b);
	m_com3.EnableWindow(b);
	m_date1.EnableWindow(b);
	m_date2.EnableWindow(b);
}
void lxrxx::wintotext()
{
	this->m_edit1.GetWindowText(edit1);
	this->m_edit2.GetWindowText(edit2);
	this->m_edit3.GetWindowText(edit3);
	this->m_edit4.GetWindowText(edit4);
	this->m_edit5.GetWindowText(edit5);
	this->m_edit6.GetWindowText(edit6);
	this->m_edit7.GetWindowText(edit7);
	this->m_edit8.GetWindowText(edit8);
	this->m_edit9.GetWindowText(edit9);
	this->m_com1.GetWindowText(com1);
	this->m_com2.GetWindowText(com2);
	this->m_com3.GetWindowText(com3);
	this->m_date1.GetWindowText(date1);
	this->m_date2.GetWindowText(date2);
}
void lxrxx::texttowin()
{
	this->m_edit1.SetWindowText(edit1);
	this->m_edit2.SetWindowText(edit2);
	this->m_edit3.SetWindowText(edit3);
	this->m_edit4.SetWindowText(edit4);
	this->m_edit5.SetWindowText(edit5);
	this->m_edit6.SetWindowText(edit6);
	this->m_edit7.SetWindowText(edit7);
	this->m_edit8.SetWindowText(edit8);
	this->m_edit9.SetWindowText(edit9);
	this->m_com1.SetWindowText(com1);
	this->m_com2.SetWindowText(com2);
	this->m_com3.SetWindowText(com3);
	this->m_date1.SetWindowText(date1);
	this->m_date2.SetWindowText(date2);
}
void lxrxx::clearall()
{
	this->m_edit1.SetWindowText("");
	this->m_edit2.SetWindowText("");
	this->m_edit3.SetWindowText("");
	this->m_edit4.SetWindowText("");
	this->m_edit5.SetWindowText("");
	this->m_edit6.SetWindowText("");
	this->m_edit7.SetWindowText("");
	this->m_edit8.SetWindowText("");
	this->m_edit9.SetWindowText("");
	this->m_com1.SetWindowText("");
	this->m_com2.SetWindowText("");
	this->m_com3.SetWindowText("");
	this->m_date1.SetWindowText("");
	this->m_date2.SetWindowText("");
}
void lxrxx::datatotext()
{
	edit1=rst2.GetFieldValue("lxrxx_id");
com1=rst2.GetFieldValue("lxrxx_qymc");
edit2=rst2.GetFieldValue("lxrxx_xm");
com2=rst2.GetFieldValue("lxrxx_xb");
edit3=rst2.GetFieldValue("lxrxx_nl");
com3=rst2.GetFieldValue("lxrxx_zw");
edit4=rst2.GetFieldValue("lxrxx_bgdh");
edit5=rst2.GetFieldValue("lxrxx_Email");
date1=rst2.GetFieldValue("lxrxx_csny");
edit6=rst2.GetFieldValue("lxrxx_sj");
edit7=rst2.GetFieldValue("lxrxx_grjj");
date2=rst2.GetFieldValue("lxrxx_djrq");
edit8=rst2.GetFieldValue("lxrxx_xxdjr");
edit9=rst2.GetFieldValue("lxrxx_bz");
}
void lxrxx::listshow()
{
	m_list.ShowWindow(SW_SHOW);
m_edit1.ShowWindow(SW_HIDE);
m_edit2.ShowWindow(SW_HIDE);
m_edit3.ShowWindow(SW_HIDE);
m_edit4.ShowWindow(SW_HIDE);
m_edit5.ShowWindow(SW_HIDE);
m_edit6.ShowWindow(SW_HIDE);
m_edit7.ShowWindow(SW_HIDE);
m_edit8.ShowWindow(SW_HIDE);
m_edit9.ShowWindow(SW_HIDE);
m_com1.ShowWindow(SW_HIDE);
m_com2.ShowWindow(SW_HIDE);
m_com3.ShowWindow(SW_HIDE);
m_date1.ShowWindow(SW_HIDE);
m_date2.ShowWindow(SW_HIDE);
}
void lxrxx::textshow()
{
	m_list.ShowWindow(SW_HIDE);
m_edit1.ShowWindow(SW_SHOW);
m_edit2.ShowWindow(SW_SHOW);
m_edit3.ShowWindow(SW_SHOW);
m_edit4.ShowWindow(SW_SHOW);
m_edit5.ShowWindow(SW_SHOW);
m_edit6.ShowWindow(SW_SHOW);
m_edit7.ShowWindow(SW_SHOW);
m_edit8.ShowWindow(SW_SHOW);
m_edit9.ShowWindow(SW_SHOW);
m_com1.ShowWindow(SW_SHOW);
m_com2.ShowWindow(SW_SHOW);
m_com3.ShowWindow(SW_SHOW);
m_date1.ShowWindow(SW_SHOW);
m_date2.ShowWindow(SW_SHOW);
}
void lxrxx::numauto()
{
	
		ado rst3;
		rst3.rstOpen("select * from tb_Client_lxrxx");
		if(rst3.GetRecordCount()==0)
		{
this->m_edit1.SetWindowText("LXR001");
this->m_edit1.EnableWindow(false);
return;
		}
		
	rst3.rstOpen("select * from tb_Client_lxrxx");
	rst3.MoveLast();
	CString mm=rst3.GetFieldValue("lxrxx_id");
	int xuhao=atoi(mm.Right(3));
	xuhao+=1;
	mm.Format("LXR%03d",xuhao);
	this->m_edit1.EnableWindow(false);
	
	this->m_edit1.SetWindowText(mm);
	rst3.close();
}
void lxrxx::enbutton(bool butn)
{
	toolbar.EnableButton(ID_ADD,butn);
	toolbar.EnableButton(ID_UPDATE,butn);
	toolbar.EnableButton(ID_DELETE,butn);
	toolbar.EnableButton(ID_UP,butn);
	toolbar.EnableButton(ID_NEXT,butn);
	toolbar.EnableButton(ID_FIRST,butn);
	toolbar.EnableButton(ID_LAST,butn);
	toolbar.EnableButton(ID_SAVE,!butn);
	toolbar.EnableButton(ID_CANCEL,!butn);

}
void lxrxx::loadf()
{/*
	if(chuan.IsEmpty())

	{rst2.rstOpen("select * from tb_Client_lxrxx");}
	else
		MessageBox(chuan);
		chuanSQL.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",chuan);
	{rst2.Open(chuanSQL,adCmdText);}
	*/
rst2.rstOpen("select * from tb_Client_lxrxx");
num2=rst2.GetRecordCount();
//rst.MoveFirst();
edit1=rst2.GetFieldValue("lxrxx_id");
com1=rst2.GetFieldValue("lxrxx_qymc");
edit2=rst2.GetFieldValue("lxrxx_xm");
com2=rst2.GetFieldValue("lxrxx_xb");
edit3=rst2.GetFieldValue("lxrxx_nl");
com3=rst2.GetFieldValue("lxrxx_zw");
edit4=rst2.GetFieldValue("lxrxx_bgdh");
edit5=rst2.GetFieldValue("lxrxx_Email");
date1=rst2.GetFieldValue("lxrxx_csny");
edit6=rst2.GetFieldValue("lxrxx_sj");
edit7=rst2.GetFieldValue("lxrxx_grjj");
date2=rst2.GetFieldValue("lxrxx_djrq");
edit8=rst2.GetFieldValue("lxrxx_xxdjr");
edit9=rst2.GetFieldValue("lxrxx_bz");
}
void lxrxx::load2()
{
	ado rst;
rst.Open("select * from tb_Client_lxrxx",adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
rst.Move(ii);
}
rst.close();
}